EMT Practice Test

1. Question Content...

---

Question1: Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How can you do this in the SAP HANA studio?
There are 2 correct answers to this question.
Response:

Question2: Where can you create a filter expression?
Please choose the correct answer.
Response:

Question3: Which of the following SAP data provisioning tools can provide real-time data provisioning?
There are 3 correct answers to this question.

Question4: Which can a level hierarchy do?
Please choose the correct answer.
Response:

Question5: You want to use a table to store results for each session but do not want to recreate the table for every session. What type of table should you create?
Please choose the correct answer.
Response:

Question6: What type of load does SAP HANA perform when starting up?
Please choose the correct answer.
Response:

Question7: You build a financial report for the company's board members that allows them to choose if they want the report to be in euros or dollars. What do you use?
Please choose the correct answer.
Response:

Question8: In what type of view can you use fuzzy text search directly?
Please choose the correct answer.
Response:

Question9: You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges?
Please choose the correct answer.
Response:

Question10: What performance techniques should you implement to improve join per- formance?
There are 3 correct answers to this question.
Response:

Question11: What PAL algorithm would you use to analyze shopping baskets?
Please choose the correct answer.
Response:

Question12: Which of the following data provisioning tools can you use to read data directly from Twitter?
There are 3 correct answers to this question.

Question13: You are using the SAP HANA studio.
Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed?
There are 3 correct answers to this question.
Response:

Question14: What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

Question15: What can you use to limit the number of records produced by a calculation view?
There are 3 correct answers to this question.
Response:

Question16: What can a variable be used for?
Please choose the correct answer.
Response:

Question17: You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
Response:

Question18: You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
Response:

Question19: What artifacts do you use in the output area of a decision table node?
There are 2 correct answers to this question.
Response:

Question20: Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge?
There are 2 correct answers to this question.
Response: